const mysql = require("mysql");
const config = require("../config");

class Mysql {
    constructor() {
        this.connection =  mysql.createConnection(config.mysql);
        this.connection.connect();
    }

    /**
     *
     * @param params object
     * {
     *     sql: 'sql语句'  select * from user where id = ?
     *     data: [1]   参数
     * }
     */
    query (params) {
      return new Promise((resolve,reject) => {
            this.connection.query(params.sql, params.data, function (error, results, fields) {
                if (error) {
                    reject(error)
                } else {
                    resolve(results)
                }
            });
        });
    }
}

module.exports = new Mysql();
